2013-04-09- 5993.200-5994.200- Rel Notes- Freight forwarder Speed integration & FTN moving to new SFTP tradenetworks & Header Issue. #DotNetReleases2013

Release Notes 5993.200-5994.200- Rel Notes - DSSCO- FTN moving to new SFTP tradenetworks & Freight forwarder Speed integration & Header Issues

Admin Info

Purpose
 FTN moving to new SFTP tradenetworks & Freight forwarder Speed integration & Header Issues
Release No#
 001
Submitted on
 04/09/2013
Submitted by
 Sandeep J
Source/Destination Systems
 NEC DEV/NEC QA
Release Sent To
 Babu Lankipallli,Baiwa Zhang
Objects Created By
 Sandeep J
Objects Tested By
 Sandeep J / Babu Lankipalli

Transport and Technical Objects

Location Objects Name
\\10.114.165.54\dev\DSSCODEV\Move To Q\FTP
  • FTPFTN.bat
  • DSSCOPOFTPProcess
  • DSSCOPOFTPProcess.exe
  • FTPSpeed.bat
  • example.txt

\\10.114.165.54\dev\DSSCODEV\Move To Q\FTP
  • FTP_QA.sql

Release Notes

For Infrastructure


Please install winscp, third party tool for SFTP in Q environment.
It can be downloaded from Web.

Please take backup of existing pages in QA before replacing QA page with Dev Pages.

Run the below Sql Script in QA DB: Location of script is given in Location Objects Name above:

Please create folder with Name: 'SPEED' in BACKUP and EXPORTS folders.


Test Notes

Speed:
Test Case ID
 Test Case Name
 Tested Environment
 Steps
 Expected Results
DSSCO_TC_FTP_001
 Verify a PO having Speed data in OpenPO and Openpos_prev tables .
 Dev
 1.Take PO(4600003060) and verify the data in OPenPO and Openpos_prev tables.
 PO(4600003060) Number data should be preset in both OPenPO and Openpos_prev tables.
DSSCO_TC_FTP_002
 Verify exfacdate falls between current date + 30 days in OpenPOs table.
 Dev
 1. Change the exfacdate in openpos table for the selected PO (4600003060).
2. Run the FTP job.
 1.Exfacdate should be changed for selected PO in Openpos table.
2. PO file should be created for selected PO Number (4600003060) in Speed Folder.


Reference Document (Specifications or Production Support Break Fix)

2013-03-28-5993.200 -Spec-DSSCO FTP Process (FTN moving to new SFTP tradenetworks)
2013-03-28-5994.200-Spec-DSSCO FTP Process (New Carrier 'Speed' integration).
2013-04-04-5835-Break Fix-FTN PO files missing header info